Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$ASM_FILE

In an Automatic Storage Management instance, `V$ASM_FILE` displays one row for every Automatic Storage Management file in every disk group mounted by the Automatic Storage Management instance. In a database instance, `V$ASM_FILE` displays no rows.

Column | Datatype | Description
--- | --- | ---
`GROUP_NUMBER` | `NUMBER` | Number of the disk group containing the file (composite primary key)
`FILE_NUMBER` | `NUMBER` | Number of the file within the disk group (composite primary key)
`COMPOUND_INDEX` | `NUMBER` | A 32-bit number consisting of a disk group number in the high-order 8 bits and a file number in the low-order 24 bits (for efficient access to the view)
`INCARNATION` | `NUMBER` | Incarnation number for the file (composite primary key)
`BLOCK_SIZE` | `NUMBER` | Block size of the file (in bytes)
`BLOCKS` | `NUMBER` | Number of blocks in the file
`BYTES` | `NUMBER` | Number of bytes in the file
`SPACE` | `NUMBER` | Number of bytes allocated to the file
`TYPE` | `VARCHAR2(64)` | Type of the file. Possible values are as follows: `CONTROLFILE` `DATAFILE` `ONLINELOG` `ARCHIVELOG` `TEMPFILE` `BACKUPSET` `XTRANSPORT` `PARAMETERFILE` `DATAGUARDCONFIG` `FLASHBACK` `CHANGETRACKING` `DUMPSET` `AUTOBACKUP`
`REDUNDANCY` | `VARCHAR2(6)` | Redundancy of the file: `UNPROT` `MIRROR` `PARITY` `HIGH`
`STRIPED` | `VARCHAR2(6)` | Indicates how the file is striped: `FINE` `COARSE`
`CREATION_DATE` | `DATE` | Date on which the file was created
`MODIFICATION_DATE` | `DATE` | Date of the last open/close for writing,rounded back to the nearest hour
`REDUNDANCY_LOWERED` | `VARCHAR2(1)` | Indicates whether a file has lower redundancy than what was expected (`Y`) or not (`N`). Redundancy is said to have been lowered for a file when one or more data extents in that file are not mirrored at the level specified by the administrator. In case of unprotected files, data extents could be missing altogether. Another possible value for this column is (`U`), which means that it is unknown.